[dbo].[Exhb

Property	Value
Created	3:12:14 PM Friday, January 07, 2011
Last Modified	11:40:02 AM Monday, February 20, 2012

Property

Value

Created

3:12:14 PM Friday, January 07, 2011

Last Modified

11:40:02 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)
$Cluster Key iExhb_FormID: EXHB_ID\MEET_ID$	EXHB_ID	varchar(10)	10
$Cluster Key iExhb_FormID: EXHB_ID\MEET_ID$	MEET_ID	varchar(10)	10
	FORM_ID	varchar(10)	10
	FORM_DATE_RECD	datetime	8
	FORM_CONTACT	varchar(40)	40
	TIME_STAMP	timestamp	8

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Key iExhb_FormID: EXHB_ID\MEET_ID$

EXHB_ID

varchar(10)

$Cluster Key iExhb_FormID: EXHB_ID\MEET_ID$

MEET_ID

varchar(10)

FORM_ID

varchar(10)

FORM_DATE_RECD

datetime

FORM_CONTACT

varchar(40)

TIME_STAMP

timestamp

	Name	Columns
$Cluster Key iExhb_FormID: EXHB_ID\MEET_ID$	iExhb_FormID	EXHB_ID, MEET_ID

Name

Columns

$Cluster Key iExhb_FormID: EXHB_ID\MEET_ID$

iExhb_FormID

EXHB_ID, MEET_ID

Type	Action	Owning Principal
Grant	Delete	IMIS
Grant	Insert	IMIS
Grant	References	IMIS
Grant	Select	IMIS
Grant	Update	IMIS

Type

Action

Owning Principal

Grant

Delete

IMIS

Grant

Insert

IMIS

Grant

References

IMIS

Grant

Select

IMIS

Grant

Update

IMIS

SQL Script

CREATE TABLE [dbo].[Exhb_Form]
(
[EXHB_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MEET_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FORM_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FORM_DATE_RECD] [datetime] NULL,
[FORM_CONTACT] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
CREATE CLUSTERED INDEX [iExhb_FormID] ON [dbo].[Exhb_Form] ([EXHB_ID], [MEET_ID]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Exhb_Form] TO [IMIS]
GRANT SELECT ON  [dbo].[Exhb_Form] TO [IMIS]
GRANT INSERT ON  [dbo].[Exhb_Form] TO [IMIS]
GRANT DELETE ON  [dbo].[Exhb_Form] TO [IMIS]
GRANT UPDATE ON  [dbo].[Exhb_Form] TO [IMIS]
GO